{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Tjek","Omregnere","GL_Satser","Satser","kommuner_afd","regnemaskine"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tjek","index":0,"n_rows":84,"n_cols":27,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null,null,"Satser pr. 1-3-2013 til 1-3-2020",null,null,null,null,null,"Slet indtastninger: <Ctrl>+q",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-01"]
[null,{"$f":"VLOOKUP(C9,C60:E63,2,FALSE)","v":{"$error":"#N/A"}},"LØNTJEK",null,null,null,null,null,"OVERENSKOMST: DEA / Pleje og omsorg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-01"]
[null,{"$f":"C17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-01"]
[null,null,"Måned, lønseddel",null,null,null,null,null,"Grundløn:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-01"]
[null,null,"2020-02-01",null,null,null,null,null,"Grundløn",null,{"$f":"IFERROR(VLOOKUP(stilling,grundløn,VLOOKUP(C6,kolonne_nr,2,TRUE)+3,FALSE)/fuldtidsnorm*timetal,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-01"]
[null,null,{"$f":"IF(C6<>\"\",DATE(YEAR(C6),MONTH(C6)-1,DAY(C6)),\"\")","v":"2020-01-01"},null,null,null,null,null,"Ajourføringstillæg",null,{"$f":"IFERROR((VLOOKUP(1,ajour,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE))/fuldtidsnorm*$C$20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01"]
[null,null,"Stilling:",null,null,null,null,null,"Gruppetillæg (geografi)",null,{"$f":"IFERROR(VLOOKUP(område,område_tillæg,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE)/fuldtidsnorm*$C$20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-11-01"]
[null,null,null,null,null,null,null,null,"Tillæg:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01"]
[null,null,null,null,null,null,null,null,"Kvalifikationsløn (års anciennitet)",null,{"$f":"IFERROR(IF(VLOOKUP(stilling,erfa_gruppe,2,FALSE)=1,VLOOKUP(J11,erfa_ikkeudd,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,TRUE),VLOOKUP(J11,erfa_uddannet,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,TRUE))/fuldtidsnorm*$C$20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,null,null,"Funktionsløn, lokalt aftalt",null,{"$f":"J13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01"]
[null,null,null,null,null,null,null,null,"Kvalifikationsløn, lokalt aftalt",null,{"$f":"J14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-01"]
[null,null,"Område/løngruppe (Bilag 1):",null,null,null,null,null,"Fast månedsløn",null,{"$f":"SUM(K6:K14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-01"]
[null,null,null,null,null,null,null,null,"Timeløn",null,{"$f":"IFERROR((K16/timetal*fuldtidsnorm)*12/1924,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-08-01"]
[null,null,"Timetal (timer/uge jf. ansættelsesbrev):",null,null,null,null,null,"Særydelser:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
[null,null,null,null,null,null,null,null,"Merarbejde/udbetalt afsp.",null,{"$f":"K17*(CEILING(J20*2,1)/2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-10-01"]
[null,null,{"$f":"\"(svarende til \"&ROUND(timetal*52/12,2)&\" timer/måned)\"","v":"(svarende til 0 timer/måned)"},null,null,null,null,null,"Overarbejde",null,{"$f":"K17*(1+50%)*(CEILING(J21*2,1)/2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01"]
[null,null,null,null,null,null,null,null,"Timer; 18-07",null,{"$f":"IFERROR(J23*VLOOKUP(3,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01"]
[null,null,null,null,null,null,null,null,"Timer; lørdag/mandag",null,{"$f":"IFERROR((CEILING(J24*2,1)/2)*VLOOKUP(4,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01"]
[null,null,null,null,null,null,null,null,"Timer; søn- og helligdag",null,{"$f":"IFERROR((CEILING(J25*2,1)/2)*(K17*VLOOKUP(5,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-01"]
[null,null,null,null,null,null,null,null,"Omlagt tjeneste",null,{"$f":"IFERROR(J27*VLOOKUP(1,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-01"]
[null,null,null,null,null,null,null,null,"Inddraget fridøgn",null,{"$f":"IFERROR(J29*VLOOKUP(2,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01"]
[null,null,null,null,null,null,null,null,"Rådighedsvagt fra bolig",null,{"$f":"IFERROR(J31*VLOOKUP(6,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01"]
[null,null,null,null,null,null,null,null,"Standby vagt",null,{"$f":"IFERROR(J33*VLOOKUP(7,særydelser,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-12-01"]
[null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask)",null,{"$f":"IF(G35<>\"\",VLOOKUP(8,særydelser,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE)*timetal*52/12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01"]
[null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask og tøj)",null,{"$f":"IF(G36<>\"\",VLOOKUP(9,særydelser,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE)*timetal*52/12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01"]
[null,null,null,null,null,null,null,null,"ferieberettiget løn",null,{"$f":"SUM(K20:K31,K35:K36,K16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01"]
[null,null,null,null,null,null,null,null,"særlig opsparing",null,{"$f":"IFERROR(K38*VLOOKUP(1,Særlig_opsp,VLOOKUP(C6,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-01"]
[null,null,null,null,null,null,null,null,"pensionsgivende løn",null,{"$f":"K38+K40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-01"]
[null,null,null,null,null,null,null,null,false,{"$f":"IF(I44=TRUE,13.2%,\"\")","v":""},{"$f":"IFERROR(J44*K42,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-01"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, medarbejder",{"$f":"IF(J44=\"\",\"\",J44/3)","v":""},{"$f":"IFERROR(J45*$K$42,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, arbejdsgiver",{"$f":"IF(J44=\"\",\"\",J44/3*2)","v":""},{"$f":"IFERROR(J46*$K$42,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01"]
[null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01"]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01"]
[null,null,"Ikke-uddannede, husassistenter, \nservicemedarb.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01"]
[null,null,"Hjemmehjælpere",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01"]
[null,null,"Social- og sundhedshjælpere, sygehjælpere, beskæftigelsesvejl., sundhedsmedhjælper",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01"]
[null,null,"Social- og sundhedsassistenter, plejehjemsass., plejere",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-01"]

{"sheet":"Omregnere","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"minutter","decimaltal"]
[null,null,30,{"$f":"C3/60","v":0.5}]
[]
[null,null,"Timer pr.\nuge","timer pr.\nmåned"]
[null,null,37,{"$f":"ROUND(C6*52/12,2)","v":160.33000000000001}]
[]
[null,null,"lokalt\ntillæg\nreduceret","timetal\n/uge el. måned","lokalt \ntillæg \nfuldt"]
[null,null,600,18.5,{"$f":"IF(D9>1924/52,ROUND(C9/D9*(1924/12),0),ROUND(C9/D9*37,0))","v":1200}]

{"sheet":"GL_Satser","index":2,"n_rows":33,"n_cols":28,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,null,"§5, 1",null,null,"§5, 2",null,null,"§9",null,"§ 17, 5","§ 17, 8","§ 18, 1","§ 18, 2","§ 18, 3","§ 19, 1","§19, 1","§20",null,null,null,null,null,"§26","§25"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
[null,"1. marts 2013","Grundløn",null,null,"servicetill.","anciennitet","anciennitet","særlig opsp.",null,"omlagte timer","inddraget",null,null,null,"Rådighed","Rådighed","standby",null,null,null,null,null,"Beklædningsgodtgørelse"]
[null,null,null,null,null,null,null,null,null,null,null,"fridøgn","18-07","lø/ma","sø/hell.","bopæl","vagtvær.",null,null,null,null,null,null,"vask","vask og tøj"]
[1,"Ikke-uddannede, husass., servicemedarb",20211.009999999998,null,null,2.85,null,null,0.01,null,44.5,368.6,36.28,29.31,0.5,34,0.75,19.059999999999999,null,null,null,null,null,0.87,2]
[2,"Hjemmehjælpere",20716.11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87,2]
[3,"SSHJ, sygehj. m.fl.",21210.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87,2]
[4,"SSA, plejehj.ass., plejere",22088.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87,2]
[]
["§ 5, 3","Områdetillæg"]
[0,0,null,"fuld tid, månedsnorm",null,null,null,null,null,"-> 30-04-2012",43.28,358.49,35.29,28.51,0.5,33.07,0.75,18.54]
[1,500,null,37,null,null,"2012-03-01","2013-03-01",null,"2012-05-01",43.89,363.51,35.78,28.91,0.5,33.53,0.75,18.8]
[2,500,null,null,null,"Ikke-uddannede, husass., servicemedarb",19914.400000000001,20211.009999999998,null,"2013-03-01",44.5,368.6,36.28,29.31,0.5,34,0.75,19.059999999999999]
[3,1000,null,null,null,"Hjemmehjælpere",20419.5,20716.11]
[4,1000,null,null,null,"SSHJ, sygehj. m.fl.",20913.61,21210.22]
[null,null,null,null,null,"SSA, plejehj.ass., plejere",21792.04,22088.65,null,43.89]
[null,"Erfaringstillæg",null,null,null,null,null,null,null,363.51]
["§ 6, 1",1,"2-4",null,null,null,null,null,null,35.78]
[0,0,0,null,null,null,null,null,null,28.91]
[1,0,0,null,null,null,null,null,null,0.5]
[2,946.75,846.75,null,null,null,null,null,null,33.53]
[3,946.75,846.75,null,null,null,null,null,null,18.8]
[4,946.75,846.75]
[5,946.75,846.75]
[6,1646.75,1446.75]
[7,1646.75,1446.75]
[8,1646.75,1446.75]
[]
[]
["§ 16, 1 og 2","pension"]
[null,"egetbidrag","arbejdsgiverbidrag"]
[]
[0.13200000000000001,4.3999999999999997E-2,8.7999999999999995E-2]

{"sheet":"Satser","index":3,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["fuld tid, månedsnorm",null,null,null,null,null,null,1,2,3,4,5,6,7,8]
[37,null,null,null,null,null,"2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","2019-03-01","2020-03-01"]
[null,null,null,"§5, 2","servicetill.",1,null,2.85,2.85,2.85,2.85,2.85,2.85,2.85]
[null,null,null,null,"pr. md",1,null,{"$f":"H3*1924/12","v":456.95000000000005},{"$f":"I3*1924/12","v":456.95000000000005},456.95000000000005,456.95000000000005,{"$f":"L3*1924/12","v":456.95000000000005},456.95000000000005,456.95000000000005]
[null,null,null,"§9","Særlig opsp.",1,null,0.01,1.2999999999999999E-2,1.7000000000000001E-2,0.02,2.7E-2,3.4000000000000002E-2,0.04]
[]
[]
["Kolonnenummer:",null,null,null,null,null,null,null,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2]
["2012-03-01",0,null,"§ 17, 5","omlagte timer",1,43.89,44.5,{"$f":"H9*(1+I$8)","v":45.167499999999997},{"$f":"I9*(1+J$8)","v":45.890180000000001},46.670313059999998,47.42,48.18,48.95]
["2013-03-01",1,null,"§ 17, 8","inddraget fridøgn",2,363.51,368.6,{"$f":"H10*(1+I$8)","v":374.12899999999996},380.11506399999996,386.57702008799993,392.77,399.05,405.43]
["2014-03-01",2,null,"§ 18, 1","18-07",3,35.78,36.28,{"$f":"H11*(1+I$8)","v":36.824199999999998},37.413387199999995,38.049414782399992,38.659999999999997,39.28,39.909999999999997]
["2015-03-01",3,null,"§ 18, 2","lø/ma",4,28.91,29.31,{"$f":"H12*(1+I$8)","v":29.749649999999995},30.225644399999997,30.739480354799994,31.23,31.73,32.24]
["2016-03-01",4,null,"§ 18, 3","sø/hell.",5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["2017-03-01",5,null,"§ 19, 1","Rådighed, fra bopæl",6,33.53,34,34.51,35.062159999999999,35.658216719999999,36.229999999999997,36.81,37.4]
["2018-03-01",6,null,"§20","Standby-vagt",7,18.8,19.059999999999999,19.345899999999997,19.655434399999997,19.989576784799997,20.309999999999999,20.63,20.96]
["2019-03-01",7,null,"§26","Bekl.godtg./vask",8,0.87,0.87,0.87,0.87,0.87,0.87,0.87,0.87]
[null,null,null,"§25","Bekl.godtg./vask og tøj",9,2,2,2,2,2,2,2,2]
[]
[null,null,null,"§5, 1","Grundløn",null,null,null,2.1,2.25,2.4,2.5,2.5,2.5]
[null,null,null,null,"Ikke-uddannede, husassistenter, \nservicemedarb.",null,null,20211.009999999998,{"$f":"ROUND(H20+(I$19*1924/12),2)","v":20547.71},{"$f":"ROUND(I20+(J$19*1924/12),2)","v":20908.46},"21,293,24",21694.07,{"$f":"ROUND(L20+(M$19*1924/12),2)","v":22094.9},{"$f":"ROUND(M20+(N$19*1924/12),2)","v":22495.73}]
[null,null,null,null,"Hjemmehjælpere",null,null,20716.11,{"$f":"H21+(I$19*1924/12)","v":21052.81},21413.56,"21,798,34",22199.17,{"$f":"ROUND(L21+(M$19*1924/12),2)","v":22600},23000.83]
[null,null,null,null,"Social- og sundhedshjælpere, sygehjælpere, beskæftigelsesvejl., sundhedsmedhjælper",null,null,21210.22,{"$f":"H22+(I$19*1924/12)","v":21546.920000000002},21907.670000000002,22292.47,22693.279999999999,{"$f":"ROUND(L22+(M$19*1924/12),2)","v":23094.11},23494.94]
[null,null,null,null,"Social- og sundhedsassistenter, plejehjemsass., plejere",null,null,22088.65,{"$f":"H23+(I$19*1924/12)","v":22425.350000000002},22786.100000000002,23170.9,23571.71,{"$f":"ROUND(L23+(M$19*1924/12),2)","v":23972.54},24373.37]
[]
[null,null,null,"§ 5, 3","Områdetillæg"]
[null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,1,null,500,500,500,500,500,500,500]
[null,null,null,null,null,2,null,500,500,500,500,500,500,500]
[null,null,null,null,null,3,null,1000,1000,1000,1000,1000,1000,1000]
[null,null,null,null,null,4,null,1000,1000,1000,1000,1000,1000,1000]
[]
[null,null,null,"§ 6, 1","erfaringstillæg, ikke uddannede m.fl. "]
[null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,1,null,0,0,0,0,0,0,0]
[null,null,null,null,null,2,null,946.75,946.75,946.75,946.75,946.75,946.75,946.75]
[null,null,null,null,null,3,null,946.75,946.75,946.75,946.75,946.75,946.75,946.75]
[null,null,null,null,null,4,null,946.75,946.75,946.75,946.75,946.75,946.75,946.75]
[null,null,null,null,null,5,null,946.75,946.75,946.75,946.75,946.75,946.75,946.75]
[null,null,null,null,null,6,null,1646.75,1646.75,1646.75,1646.75,1646.75,1646.75,1646.75]
[null,null,null,null,null,7,null,1646.75,1646.75,1646.75,1646.75,1646.75,1646.75,1646.75]
[null,null,null,null,null,8,null,1646.75,1646.75,1646.75,1646.75,1646.75,1646.75,1646.75]
[]
[null,null,null,"§ 6, 1","erfaringstillæg, øvrige"]
[null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,1,null,0,0,0,0,0,0,0]
[null,null,null,null,null,2,null,846.75,846.75,846.75,846.75,846.75,846.75,846.75]
[null,null,null,null,null,3,null,846.75,846.75,846.75,846.75,846.75,846.75,846.75]
[null,null,null,null,null,4,null,846.75,846.75,846.75,846.75,846.75,846.75,846.75]
[null,null,null,null,null,5,null,846.75,846.75,846.75,846.75,846.75,846.75,846.75]
[null,null,null,null,null,6,null,1446.75,1446.75,1446.75,1446.75,1446.75,1446.75,1446.75]
[null,null,null,null,null,7,null,1446.75,1446.75,1446.75,1446.75,1446.75,1446.75,1446.75]
[null,null,null,null,null,8,null,1446.75,1446.75,1446.75,1446.75,1446.75,1446.75,1446.75]
[]
[]
[]
[]
[null,null,null,null,"Ikke-uddannede, husassistenter, \nservicemedarb.",1]
[null,null,null,null,"Hjemmehjælpere",2]
[null,null,null,null,"Social- og sundhedshjælpere, sygehjælpere, beskæftigelsesvejl., sundhedsmedhjælper",2]
[null,null,null,null,"Social- og sundhedsassistenter, plejehjemsass., plejere",2]

{"sheet":"kommuner_afd","index":4,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":true,"merged":[]}
["k.nr.","k.navn","løngruppe",null,null,null,null,"Liste, stillinger"]
[165,"Albertslund",4,null,165,1,null,"Ikke-uddannede, husass., servicemedarb",1]
[201,"Allerød",3,null,201,1,null,"Hjemmehjælpere",2]
[420,"Assens",0,null,420,3,null,"SSHJ, sygehj. m.fl.",3]
[151,"Ballerup",4,null,151,1,null,"SSA, plejehj.ass., plejere",4]
[530,"Billund",0,null,530,3]
[400,"Bornholm",0,null,400,1]
[153,"Brøndby",4,null,153,1]
[810,"Brønderslev-Dronninglund",0,null,810,5]
[155,"Dragør",4,null,155,1]
[240,"Egedal",4,null,240,1]
[561,"Esbjerg",1,null,561,3]
[563,"Fanø",0,null,563,3]
[710,"Favrskov",0,null,710,4]
[320,"Faxe",0,null,320,2]
[210,"Fredensborg",3,null,210,1]
[607,"Fredericia",0,null,607,3]
[147,"Frederiksberg",4,null,147,1]
[813,"Frederikshavn",1,null,813,5]
[250,"Frederikssund",3,null,250,1]
[190,"Furesø",4,null,190,1]
[430,"Faaborg-Midtfyn",1,null,430,3]
[157,"Gentofte",4,null,157,1]
[159,"Gladsaxe",4,null,159,1]
[161,"Glostrup",4,null,161,1]
[253,"Greve",4,null,253,2]
[270,"Gribskov",3,null,270,1]
[376,"Guldborgsund",0,null,376,2]
[510,"Haderslev",0,null,510,3]
[260,"Halsnæs",3,null,260,1]
[766,"Hedensted",0,null,766,4]
[217,"Helsingør",3,null,217,1]
[163,"Herlev",4,null,163,1]
[657,"Herning",0,null,657,4]
[219,"Hillerød",3,null,219,1]
[860,"Hjørring",0,null,860,5]
[316,"Holbæk",0,null,316,2]
[661,"Holstebro",0,null,661,4]
[615,"Horsens",0,null,615,4]
[167,"Hvidovre",4,null,167,1]
[169,"Høje-Taastrup",4,null,169,1]
[223,"Hørsholm",3,null,223,1]
[756,"Ikast-Brande",0,null,756,4]
[183,"Ishøj",4,null,183,1]
[849,"Jammerbugt",0,null,849,5]
[326,"Kalundborg",1,null,326,2]
[440,"Kerteminde",1,null,440,3]
[621,"Kolding",0,null,621,3]
[101,"København",4,null,101,1]
[259,"Køge",2,null,259,2]
[482,"Langeland",0,null,482,3]
[350,"Lejre",2,null,350,2]
[665,"Lemvig",0,null,665,4]
[360,"Lolland",0,null,360,2]
[173,"Lyngby-Taarbæk",4,null,173,1]
[825,"Læsø",0,null,825,5]
[846,"Mariagerfjord",0,null,846,5]
[410,"Middelfart",0,null,410,3]
[773,"Morsø",0,null,773,5]
[707,"Norddjurs",0,null,707,4]
[480,"Nordfyn",0,null,480,3]
[450,"Nyborg",1,null,450,3]
[370,"Næstved",1,null,370,2]
[727,"Odder",0,null,727,4]
[461,"Odense",1,null,461,3]
[306,"Odsherred",0,null,306,2]
[730,"Randers",0,null,730,4]
[840,"Rebild",0,null,840,5]
[760,"Ringkøbing-Skjern",0,null,760,4]
[329,"Ringsted",0,null,329,2]
[265,"Roskilde",2,null,265,2]
[230,"Rudersdal",4,null,230,1]
[175,"Rødovre",4,null,175,1]
[741,"Samsø",0,null,741,4]
[740,"Silkeborg",0,null,740,4]
[746,"Skanderborg",1,null,746,4]
[779,"Skive",0,null,779,4]
[330,"Slagelse",1,null,330,2]
[269,"Solrød",2,null,269,2]
[340,"Sorø",0,null,340,2]
[336,"Stevns",0,null,336,2]
[671,"Struer",0,null,671,4]
[479,"Svendborg",0,null,479,3]
[706,"Syddjurs",0,null,706,4]
[540,"Sønderborg",1,null,540,3]
[787,"Thisted",0,null,787,5]
[550,"Tønder",0,null,550,3]
[185,"Tårnby",4,null,185,1]
[187,"Vallensbæk",4,null,187,1]
[573,"Varde",0,null,573,3]
[575,"Vejen",0,null,575,3]
[630,"Vejle",0,null,630,3]
[820,"Vesthimmerland",0,null,820,5]
[791,"Viborg",0,null,791,4]
[390,"Vordingborg",0,null,390,2]
[492,"Ærø",0,null,492,3]
[580,"Aabenraa",0,null,580,3]
[851,"Ålborg",1,null,851,5]
[751,"Århus",2,null,751,4]

{"sheet":"regnemaskine","index":5,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social- og sundhedshjælper, Geografi: Gribskov Kommune"]
[]
[null,null,"Timer/uge",null,28,null,null,null,"Timer/uge",null,31,null,null,null,null,"Timer/uge",null,null,null,null,"Satser:"]
[null,null,"Timetal (faste timer pr. måned)",null,121.333,null,null,null,"Timetal (faste timer pr. måned)",null,134.3433,null,null,null,null,"Timetal (faste timer pr. måned)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(input)","(beregninger)"]
[null,null,"grundløn",null,15918.561672972974,null,null,null,"grundløn",null,17625.477869999999,null,null,null,null,"grundløn",null,null,null,"§ 5a, 1"]
[null,null,"servicetillæg",null,382.19138245322245,null,null,null,"servicetillæg",null,423.17301600000002,null,null,null,null,"gruppetillæg",null,null,null,"§ 5a, 2"]
[null,null,"gruppetillæg",null,812.75452390852388,null,null,null,"gruppetillæg",null,449.95229999999998,null,null,null,null,"servicetillæg",null,null,null,"§ 5b"]
[null,null,"K-løn, ok (års anciennitet)",7,1029.7463602079001,null,null,null,"K-løn, ok (års anciennitet)",1,0,null,null,null,null,"K-løn, ok (års anciennitet)",null,null,null,"§ 7, 1"]
["*",null,"K-løn, lokalt aftalt",3450,2610.8036382536379,null,null,null,"K-løn, lokalt aftalt",null,0,null,null,"*",null,"K-løn, lokalt aftalt",null,null,null,"§ 7, 2"]
["*",null,"K-løn, lokalt aftalt",null,0,null,null,null,"K-løn, lokalt aftalt",null,0,null,null,"*",null,"K-løn, lokalt aftalt",null,null,null,"§ 7, 2"]
["*","u","F-løn, lokalt aftalt",500,500,null,null,null,"F-løn, lokalt aftalt",null,0,null,null,"*","u","F-løn, lokalt aftalt",null,null,null,"§ 6"]
["*",null,"F-løn, lokalt aftalt",null,0,null,null,null,"F-løn, lokalt aftalt",null,0,null,null,"*",null,"F-løn, lokalt aftalt",null,null,null,"§ 6"]
[null,null,"* 'u'; uden reduktion ved deltid",null,null,null,null,null,"fast månedsløn",null,18498.603186,null,null,null,null,"* 'u'; uden reduktion ved deltid"]
[null,null,"fast månedsløn",null,21254.057577796259,null,null,null,"timeløn",null,137.69650727650728,null,null,null,null,"fast månedsløn"]
[null,null,"timeløn",null,175.17128545240175,null,null,null,null,null,null,null,null,null,null,"timeløn"]
[null,null,null,null,null,null,null,null,"merarbejde/udbetalt afsp.",null,0]
[null,null,"merarbejde/udbetalt afsp.",18,3153.0831381432313,null,null,null,"overarbejde",null,0,null,null,null,null,"merarbejde/udbetalt afsp.",null,null,null,"§ 21, 3"]
[null,null,"overarbejde",null,0,null,null,null,null,null,null,null,null,null,null,"overarbejde",null,null,null,"§ 21, 1-2"]
[null,null,null,null,null,null,null,null,"timer; 18-07",null,0]
[null,null,"timer; 18-07",152,3863.84,null,null,null,"timer; lørdag/mandag",4,118.68,null,null,null,null,"timer; 18-07",null,null,null,"§ 18, 1"]
[null,null,"timer; lørdag/mandag",24,712.08,null,null,null,"timer; søn- og helligdag",8,550.7860291060291,null,null,null,null,"timer; lørdag/mandag",null,null,null,"§ 18, 2"]
[null,null,"timer; søn- og helligdag",40,3503.4257090480351,null,null,null,null,null,null,null,null,null,null,"timer; søn- og helligdag",null,null,null,"§ 18, 3"]
[null,null,null,null,null,null,null,null,"3/37 udbetalt",null,0]
[null,null,"3/37 udbetalt",152,2158.8677342241945,null,null,null,"Omlagt tjeneste",null,0,null,null,null,null,"3/37 udbetalt",null,null,null,"§ 18, 5"]
[]
[null,null,"Omlagt tjeneste",null,0,null,null,null,"Rådighedsvagt (bolig)",null,0,null,null,null,null,"Omlagt tjeneste",null,null,null,"§ 17, 5"]
[null,null,null,null,null,null,null,null,"Rådighedsvagt (vagtværelse)"]
[null,null,"Rådighedsvagt (bolig)",null,0,null,null,null,null,null,null,null,null,null,null,"Rådighedsvagt (bolig)",null,null,null,"§ 19, 1"]
[null,null,"Rådighedsvagt (vagtværelse)",null,null,null,null,null,null,null,null,null,null,null,null,"Rådighedsvagt (vagtværelse)",null,null,null,"§ 19, 1"]
[null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask)",null,0]
[null,null,"Beklædningsgodtg. (vask)",null,0,null,null,null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask)",null,null,null,"§ 25"]
[null,null,"Beklædningsgodtg. (vask og tøj)",null,0,null,null,null,"ferieberettiget løn",null,19168.069215106028,null,null,null,null,"Beklædningsgodtg. (vask og tøj)",null,null,null,"§ 25"]
[]
[null,null,"ferieberettiget løn",null,34645.354159211718,null,null,null,"særlig opsparing",null,191.6806921510603,null,null,null,null,"ferieberettiget løn",null,null,null,"§ 27"]
[]
[null,null,"særlig opsparing",null,346.45354159211718,null,null,null,"pensionsgivende løn",null,19359.74990725709,null,null,null,null,"særlig opsparing"]
[]
[null,null,"pensionsgivende løn",null,34991.807700803838,null,null,null,"pensionsprocent",0.13200000000000001,2555.4869877579358,null,null,null,null,"pensionsgivende løn",null,null,null,"§ 16, 1-3"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, medarbejder",4.3999999999999997E-2,851.82899591931186]
[null,null,"pensionsprocent",0.13200000000000001,4618.9186165061064,null,null,null,"pensionsbidrag, arbejdsgiver",8.9499999999999996E-2,1732.6976166995096,null,null,null,null,"pensionsprocent",null,null,null,"§ 16, 1-3"]
[null,null,"pensionsbidrag, medarbejder",4.3999999999999997E-2,1539.6395388353687,null,null,null,null,null,null,null,null,null,null,"pensionsbidrag, medarbejder",null,null,null,"§ 16, 1-3"]
[null,null,"pensionsbidrag, arbejdsgiver",8.9499999999999996E-2,3131.7667892219433,null,null,null,null,null,null,null,null,null,null,"pensionsbidrag, arbejdsgiver",null,null,null,"§ 16, 1-3"]